Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_ADVISOR_SQLA_WK_STMTS

`DBA_ADVISOR_SQLA_WK_STMTS` displays information about all workload objects in the database after an Access Advisor analysis operation.

Related View

`USER_ADVISOR_SQLA_WK_STMTS` displays information about the workload objects owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` |  | Owner of the task
`TASK_ID` | `NUMBER` | `NOT NULL` | Unique identifier of the task
`TASK_NAME` | `VARCHAR2(30)` |  | Name of the task
`WORKLOAD_ID` | `NUMBER` | `NOT NULL` | Unique identifier of the workload object
`WORKLOAD_NAME` | `VARCHAR2(30)` |  | Name of the workload
`SQL_ID` | `NUMBER` | `NOT NULL` | Generated identifier of the statement
`HASH_VALUE` | `NUMBER` |  | Hash value for the parent statement in the SQL cache
`USERNAME` | `VARCHAR2(30)` |  | Name of the user executing the statement
`MODULE` | `VARCHAR2(64)` |  | Name of the module issuing the statement
`ACTION` | `VARCHAR2(64)` |  | Module action for the statement
`CPU_TIME` | `NUMBER` |  | Total CPU count (in seconds) of the executing statement
`BUFFER_GETS` | `NUMBER` |  | Total number of buffer gets for the statement
`DISK_READS` | `NUMBER` |  | Total disk-read I/O count for the statement
`ELAPSED_TIME` | `NUMBER` |  | Total elapsed time (in seconds) of the executing statement
`ROWS_PROCESSED` | `NUMBER` |  | Total number of rows processed by the statement
`EXECUTIONS` | `NUMBER` |  | Total number of times the statement was executed
`PRECOST` | `NUMBER` |  | Cost of executing the statement in the workload prior to the recommendations
`POSTCOST` | `NUMBER` |  | Cost of executing the statement in the workload after the recommendations
`LAST_EXECUTION_DATE` | `DATE` |  | Date on which the statement was last executed
`PRIORITY` | `NUMBER` |  | Business importance of the statement: `1` - High `2` - Medium `3` - Low
`COMMAND_TYPE` | `NUMBER` |  | Type of the command
`STAT_PERIOD` | `NUMBER` |  | Unused
`SQL_TEXT` | `CLOB` |  | Text of the SQL statement
`IMPORTANCE` | `NUMBER` |  | Advisor-calculated importance value
`REC_ID` | `NUMBER` |  | Associated recommendation identifier

See Also: "USER_ADVISOR_SQLA_WK_STMTS"